Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

Hyperlink-Excel-Fix.zip

IsThere_Remote

Checks if a file can be reached online or no Same as

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

WebBrowser.zip

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...